Re: finding out about databases and tables - Mailing list pgsql-novice

From Lloyd Vancil
Subject Re: finding out about databases and tables
Date
Msg-id a05101033b8d118f0e251@[17.207.13.64]
Whole thread Raw
In response to finding out about databases and tables  ("Ken Gerdes" <Ken.Gerdes@lottery.state.tx.us>)
List pgsql-novice
At 2:10 PM -0600 4/3/02, Ken Gerdes wrote:
>Hi,
>
>I am relatively new to Postgresql.  I have Postgresql running on a
>Linux server, and I need to find out the names of all databases, and
>all tables within those databases, so I can start querying for data,
>and spool those results to a file for export.  Can someone please
>tell me what commands I should run as a root user to find out this
>information, and query the databases for spooling to a file?
>
>Thanks,
>
>Ken
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html

  if you have not deleted the test db

    psql test
  will get you a prompt
  \?  will get help on the \ commands
  \h  will get a list of help topics
\h topic will get a syntax for that command.

    L>

--
searchmaster@apple.com
                 lev@apple.com

pgsql-novice by date:

Previous
From: Lloyd Vancil
Date:
Subject: novice question about NOTICE:...
Next
From: Doug Silver
Date:
Subject: Re: novice question about NOTICE:...